Importing the data

In this section, we import the data for further analysis. We only imported the necessary datasets. These were: - Fahrzeuge_OEM1_Typ11.csv - Fahrzeuge_OEM1_Typ12.csv - Fahrzeuge_OEM2_Typ21.csv - Fahrzeuge_OEM2_Typ22.csv - Bestandteile_Fahrzeuge_OEM1_Typ11.cs - Bestandteile_Fahrzeuge_OEM1_Typ12.cs - Bestandteile_Fahrzeuge_OEM2_Typ21.cs - Bestandteile_Fahrzeuge_OEM2_Typ22.cs - Bestandteile_Komponente_K1BE1.csv - Bestandteile_Komponente_K1BE2.csv - Einzelteil_T02.txt - Zulassungen_alle_Fahrzeuge.csv - Geodaten_Gemeinden_v1.2_2017-08-22_TrR.csv

Additional to the provided datasheets we needed tWO more data sources to get additional geographical information for the Shiny-App: - georef-germany-postleitzahl.csv - germany_municipalities.shp

The steps for this process were as followed:

Data Preparation

After the loading of the Dataframes, the data needed to be prepared for further analysis. Those were the steps for the data preparation:

This section of the document prepares the data for subsequent analysis and ensures data consistency and quality for further investigation.

Creation of the final data set

This final dataframe was written to the CSV file named “Final_dataset_group_17.csv.”. The unused dataframes were removed.

Evaluation

TODO Content for Evaluation section goes here.

Result

TODO Content for Result section goes here.

The final Shiny app The damaged vehicle heatmap

Zoom on the heatmap that show the highest values
Zoom on the heatmap that show the highest values
The final table
The final table

Additional Information

TODO das mit Fehlerhaft erklären und noch ähnliche Sachen